#!/bin/bash

ds_no=$1

sql_cmd="INSERT OVERWRITE TABLE acrm_transaction PARTITION (ds_no='$ds_no') select customer_id ,tran_date ,tran_type , channel , amount  from  i_acrm_transaction;"

$HIVE_HOME/bin/hive -e "$sql_cmd"